# -*- coding: utf-8 -*-
from __future__ import unicode_literals
from django.db import models
class RecordFile(models.Model):
    fileId = models.AutoField(primary_key=True)
    fileName =  models.CharField(verbose_name=u'', null=False, help_text='文件名',max_length=256) 
    songId =  models.CharField(verbose_name=u'', null=False, help_text='歌曲id',max_length=20) 
    status =  models.IntegerField(verbose_name=u'', null=False, help_text='状态') 
    fileType =  models.IntegerField(verbose_name=u'', null=False, help_text='文件类型') 
    uid = models.IntegerField(verbose_name=u'',help_text="用户ID",default=0)
    
    finishTime = models.IntegerField(verbose_name=u'',help_text="结束时间",default=None)
    duration = models.IntegerField(verbose_name=u'',help_text="间隔",default=0)
    score = models.IntegerField(verbose_name=u'',help_text="分数",default=0)
    singTime = models.IntegerField(verbose_name=u'',help_text="演唱时间",default=0)
    likesCount = models.IntegerField(verbose_name=u'',help_text="点赞数量",default=0)
    forwardCount = models.IntegerField(verbose_name=u'',help_text="转发数量",default=0)
    playCount = models.IntegerField(verbose_name=u'',help_text="播放数量",default=0)

    class Meta:
        db_table =  'RecordFile'

class user_relation(models.Model):
    id = models.AutoField(primary_key=True)
    masterid = models.IntegerField(help_text="被关注者ID")
    slaveid = models.IntegerField(help_text="粉丝ID")
    class Meta:
        db_table = 'user_relation'

class song_base(models.Model):
    auto_seq = models.AutoField(primary_key=True)
    song_no = models.CharField(help_text="songid",max_length=20)
    name = models.CharField(help_text="歌曲名",max_length=20)
    singer_names = models.CharField(help_text="歌手名",max_length=20)
    pic_path = models.CharField(help_text="图片url",max_length=200)
    video_path = models.CharField(help_text="mp4URL",max_length=200)
    class Meta:
        db_table = 'song_base'

